package org.vy.dal.dao.views;

import java.util.ArrayList;
import java.util.List;

import org.vy.dal.QueryManager;

public class VyEmpModuleGroupDAO {

	private static final String FIND_BY_VY_ID = "SELECT * FROM <TABLE> WHERE VY_ID = m_vyId";

	@SuppressWarnings("unchecked")
	public static List<VyEmpModuleGroupDO> findByVyId(String key) throws Exception {
		VyEmpModuleGroupDO dto = new VyEmpModuleGroupDO();
		List<VyEmpModuleGroupDO> lst = new ArrayList<VyEmpModuleGroupDO>();
		dto.setVyId(key);
		lst = (List<VyEmpModuleGroupDO>)QueryManager.executeListQuery(dto, FIND_BY_VY_ID);
		return lst;
	}
}
